Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	23906
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.6 MiB
Average record size in memory	156.0 B

Variable types

Text	3
DateTime	1
Categorical	10
Numeric	7

Alerts

`Amount_paid_for_insurance` is highly overall correlated with `Price_($)`	High correlation
`Dealer_Name` is highly overall correlated with `Dealer_No`	High correlation
`Dealer_No` is highly overall correlated with `Dealer_Name`	High correlation
`Engine` is highly overall correlated with `Transmission`	High correlation
`Price_($)` is highly overall correlated with `Amount_paid_for_insurance`	High correlation
`Transmission` is highly overall correlated with `Engine`	High correlation
`Car_id` has unique values	Unique
`Claim_amount` has 21516 (90.0%) zeros	Zeros

Reproduction

Analysis started	2024-05-30 10:59:32.393720
Analysis finished	2024-05-30 11:00:20.716925
Duration	48.32 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

Car_id
Text

UNIQUE

Distinct	23906
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	286872
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23906 ?
Unique (%)	100.0%

Sample

1st row	C_CND_000001
2nd row	C_CND_000002
3rd row	C_CND_000003
4th row	C_CND_000004
5th row	C_CND_000005

Value	Count	Frequency (%)
c_cnd_000001	1	< 0.1%
c_cnd_000014	1	< 0.1%
c_cnd_000005	1	< 0.1%
c_cnd_000006	1	< 0.1%
c_cnd_000007	1	< 0.1%
c_cnd_000008	1	< 0.1%
c_cnd_000009	1	< 0.1%
c_cnd_000010	1	< 0.1%
c_cnd_000011	1	< 0.1%
c_cnd_000046	1	< 0.1%
Other values (23896)	23896	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
C	47812	16.7%
_	47812	16.7%
0	44089	15.4%
N	23906	8.3%
D	23906	8.3%
1	20181	7.0%
2	14088	4.9%
3	10088	3.5%
5	9181	3.2%
4	9181	3.2%
Other values (4)	36628	12.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	286872	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	47812	16.7%
_	47812	16.7%
0	44089	15.4%
N	23906	8.3%
D	23906	8.3%
1	20181	7.0%
2	14088	4.9%
3	10088	3.5%
5	9181	3.2%
4	9181	3.2%
Other values (4)	36628	12.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	286872	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	47812	16.7%
_	47812	16.7%
0	44089	15.4%
N	23906	8.3%
D	23906	8.3%
1	20181	7.0%
2	14088	4.9%
3	10088	3.5%
5	9181	3.2%
4	9181	3.2%
Other values (4)	36628	12.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	286872	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	47812	16.7%
_	47812	16.7%
0	44089	15.4%
N	23906	8.3%
D	23906	8.3%
1	20181	7.0%
2	14088	4.9%
3	10088	3.5%
5	9181	3.2%
4	9181	3.2%
Other values (4)	36628	12.8%

Date
Date

Distinct	612
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Minimum	2022-01-02 00:00:00
Maximum	2023-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Customer_Name
Text

Distinct	3022
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Length

Max length	16
Median length	15
Mean length	5.8355643
Min length	1

Characters and Unicode

Total characters	139505
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1169 ?
Unique (%)	4.9%

Sample

1st row	Geraldine
2nd row	Gia
3rd row	Gianna
4th row	Giselle
5th row	Grace

Value	Count	Frequency (%)
thomas	92	0.4%
emma	91	0.4%
lucas	88	0.4%
nathan	80	0.3%
louis	77	0.3%
lea	76	0.3%
chloe	74	0.3%
paul	71	0.3%
theo	65	0.3%
sarah	65	0.3%
Other values (2994)	23168	96.7%

Most occurring characters

Value	Count	Frequency (%)
a	19379	13.9%
e	14302	10.3%
i	12093	8.7%
n	11632	8.3%
l	9377	6.7%
r	7174	5.1%
o	6199	4.4%
s	4575	3.3%
h	4428	3.2%
y	4247	3.0%
Other values (45)	46099	33.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	139505	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	19379	13.9%
e	14302	10.3%
i	12093	8.7%
n	11632	8.3%
l	9377	6.7%
r	7174	5.1%
o	6199	4.4%
s	4575	3.3%
h	4428	3.2%
y	4247	3.0%
Other values (45)	46099	33.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	139505	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	19379	13.9%
e	14302	10.3%
i	12093	8.7%
n	11632	8.3%
l	9377	6.7%
r	7174	5.1%
o	6199	4.4%
s	4575	3.3%
h	4428	3.2%
y	4247	3.0%
Other values (45)	46099	33.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	139505	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	19379	13.9%
e	14302	10.3%
i	12093	8.7%
n	11632	8.3%
l	9377	6.7%
r	7174	5.1%
o	6199	4.4%
s	4575	3.3%
h	4428	3.2%
y	4247	3.0%
Other values (45)	46099	33.0%

Gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Male	18798
Female	5108

Length

Max length	6
Median length	4
Mean length	4.4273404
Min length	4

Characters and Unicode

Total characters	105840
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Male
2nd row	Male
3rd row	Male
4th row	Male
5th row	Male

Common Values

Value	Count	Frequency (%)
Male	18798	78.6%
Female	5108	21.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
male	18798	78.6%
female	5108	21.4%

Most occurring characters

Value	Count	Frequency (%)
e	29014	27.4%
a	23906	22.6%
l	23906	22.6%
M	18798	17.8%
F	5108	4.8%
m	5108	4.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	105840	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	29014	27.4%
a	23906	22.6%
l	23906	22.6%
M	18798	17.8%
F	5108	4.8%
m	5108	4.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	105840	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	29014	27.4%
a	23906	22.6%
l	23906	22.6%
M	18798	17.8%
F	5108	4.8%
m	5108	4.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	105840	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	29014	27.4%
a	23906	22.6%
l	23906	22.6%
M	18798	17.8%
F	5108	4.8%
m	5108	4.8%

Annual_Income
Real number (ℝ)

Distinct	2508
Distinct (%)	10.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	830840.29

Minimum	10080
Maximum	11200000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	186.9 KiB

Quantile statistics

Minimum	10080
5-th percentile	13500
Q1	386000
median	735000
Q3	1175750
95-th percentile	2100000
Maximum	11200000
Range	11189920
Interquartile range (IQR)	789750

Descriptive statistics

Standard deviation	720006.4
Coefficient of variation (CV)	0.86660025
Kurtosis	7.5723739
Mean	830840.29
Median Absolute Deviation (MAD)	395000
Skewness	1.7398384
Sum	1.9862068 × 10¹⁰
Variance	5.1840921 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13500	5273	22.1%
1100000	162	0.7%
600000	160	0.7%
800000	151	0.6%
1300000	148	0.6%
1200000	142	0.6%
650000	141	0.6%
1000000	133	0.6%
900000	132	0.6%
700000	128	0.5%
Other values (2498)	17336	72.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10080	1	< 0.1%
13500	5273	22.1%
24000	1	< 0.1%
85000	1	< 0.1%
106000	1	< 0.1%
121000	1	< 0.1%
131000	1	< 0.1%
145000	2	< 0.1%
160000	3	< 0.1%
170000	2	< 0.1%

Value	Count	Frequency (%)
11200000	1	< 0.1%
8000000	1	< 0.1%
7650000	1	< 0.1%
6800000	1	< 0.1%
6600000	1	< 0.1%
6500000	1	< 0.1%
6460000	1	< 0.1%
6400000	2	< 0.1%
6240000	1	< 0.1%
6125000	1	< 0.1%

Dealer_Name
Categorical

HIGH CORRELATION

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Progressive Shippers Cooperative Association No	1318
Rabun Used Car Sales	1313
Race Car Help	1253
Saab-Belle Dodge	1251
Star Enterprises Inc	1249
Other values (23)	17522

Length

Max length	47
Median length	30
Mean length	21.805614
Min length	9

Characters and Unicode

Total characters	521285
Distinct characters	47
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Buddy Storbeck's Diesel Service Inc
2nd row	C & M Motors Inc
3rd row	Capitol KIA
4th row	Chrysler of Tri-Cities
5th row	Chrysler Plymouth

Common Values

Value	Count	Frequency (%)
Progressive Shippers Cooperative Association No	1318	5.5%
Rabun Used Car Sales	1313	5.5%
Race Car Help	1253	5.2%
Saab-Belle Dodge	1251	5.2%
Star Enterprises Inc	1249	5.2%
Tri-State Mack Inc	1249	5.2%
Ryder Truck Rental and Leasing	1248	5.2%
U-Haul CO	1247	5.2%
Scrivener Performance Engineering	1246	5.2%
Suburban Ford	1243	5.2%
Other values (18)	11289	47.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	4374	5.6%
car	3191	4.0%
sales	2570	3.3%
dodge	1880	2.4%
chrysler	1880	2.4%
ford	1872	2.4%
co	1871	2.4%
association	1318	1.7%
cooperative	1318	1.7%
shippers	1318	1.7%
Other values (67)	57214	72.6%

Most occurring characters

Value	Count	Frequency (%)
	54900	10.5%
e	53665	10.3%
r	39723	7.6%
a	34108	6.5%
n	28257	5.4%
o	26081	5.0%
i	25985	5.0%
s	24245	4.7%
t	21426	4.1%
c	21343	4.1%
Other values (37)	191552	36.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	521285	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	54900	10.5%
e	53665	10.3%
r	39723	7.6%
a	34108	6.5%
n	28257	5.4%
o	26081	5.0%
i	25985	5.0%
s	24245	4.7%
t	21426	4.1%
c	21343	4.1%
Other values (37)	191552	36.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	521285	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	54900	10.5%
e	53665	10.3%
r	39723	7.6%
a	34108	6.5%
n	28257	5.4%
o	26081	5.0%
i	25985	5.0%
s	24245	4.7%
t	21426	4.1%
c	21343	4.1%
Other values (37)	191552	36.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	521285	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	54900	10.5%
e	53665	10.3%
r	39723	7.6%
a	34108	6.5%
n	28257	5.4%
o	26081	5.0%
i	25985	5.0%
s	24245	4.7%
t	21426	4.1%
c	21343	4.1%
Other values (37)	191552	36.7%

Company
Categorical

Distinct	30
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Chevrolet	1819
Dodge	1671
Ford	1614
Volkswagen	1333
Mercedes-B	1285
Other values (25)	16184

Length

Max length	10
Median length	8
Mean length	6.8641345
Min length	3

Characters and Unicode

Total characters	164094
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ford
2nd row	Dodge
3rd row	Cadillac
4th row	Toyota
5th row	Acura

Common Values

Value	Count	Frequency (%)
Chevrolet	1819	7.6%
Dodge	1671	7.0%
Ford	1614	6.8%
Volkswagen	1333	5.6%
Mercedes-B	1285	5.4%
Mitsubishi	1277	5.3%
Chrysler	1120	4.7%
Oldsmobile	1111	4.6%
Toyota	1110	4.6%
Nissan	886	3.7%
Other values (20)	10680	44.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chevrolet	1819	7.6%
dodge	1671	7.0%
ford	1614	6.8%
volkswagen	1333	5.6%
mercedes-b	1285	5.4%
mitsubishi	1277	5.3%
chrysler	1120	4.7%
oldsmobile	1111	4.6%
toyota	1110	4.6%
nissan	886	3.7%
Other values (20)	10680	44.7%

Most occurring characters

Value	Count	Frequency (%)
e	15491	9.4%
o	14320	8.7%
r	10927	6.7%
s	10338	6.3%
l	9696	5.9%
i	9524	5.8%
a	8861	5.4%
d	7773	4.7%
u	7006	4.3%
t	6400	3.9%
Other values (31)	63758	38.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	164094	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	15491	9.4%
o	14320	8.7%
r	10927	6.7%
s	10338	6.3%
l	9696	5.9%
i	9524	5.8%
a	8861	5.4%
d	7773	4.7%
u	7006	4.3%
t	6400	3.9%
Other values (31)	63758	38.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	164094	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	15491	9.4%
o	14320	8.7%
r	10927	6.7%
s	10338	6.3%
l	9696	5.9%
i	9524	5.8%
a	8861	5.4%
d	7773	4.7%
u	7006	4.3%
t	6400	3.9%
Other values (31)	63758	38.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	164094	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	15491	9.4%
o	14320	8.7%
r	10927	6.7%
s	10338	6.3%
l	9696	5.9%
i	9524	5.8%
a	8861	5.4%
d	7773	4.7%
u	7006	4.3%
t	6400	3.9%
Other values (31)	63758	38.9%

Model
Text

Distinct	154
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Length

Max length	14
Median length	11
Mean length	6.5813185
Min length	2

Characters and Unicode

Total characters	157333
Distinct characters	60
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Expedition
2nd row	Durango
3rd row	Eldorado
4th row	Celica
5th row	TL

Value	Count	Frequency (%)
grand	700	2.6%
ram	658	2.4%
coupe	435	1.6%
diamante	418	1.6%
silhouette	411	1.5%
prizm	411	1.5%
passat	391	1.5%
pickup	383	1.4%
jetta	382	1.4%
rl	372	1.4%
Other values (151)	22385	83.1%

Most occurring characters

Value	Count	Frequency (%)
a	14726	9.4%
r	13076	8.3%
e	12819	8.1%
o	9082	5.8%
t	8224	5.2%
i	8111	5.2%
n	7890	5.0%
C	5519	3.5%
l	5480	3.5%
S	5115	3.3%
Other values (50)	67291	42.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	157333	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	14726	9.4%
r	13076	8.3%
e	12819	8.1%
o	9082	5.8%
t	8224	5.2%
i	8111	5.2%
n	7890	5.0%
C	5519	3.5%
l	5480	3.5%
S	5115	3.3%
Other values (50)	67291	42.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	157333	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	14726	9.4%
r	13076	8.3%
e	12819	8.1%
o	9082	5.8%
t	8224	5.2%
i	8111	5.2%
n	7890	5.0%
C	5519	3.5%
l	5480	3.5%
S	5115	3.3%
Other values (50)	67291	42.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	157333	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	14726	9.4%
r	13076	8.3%
e	12819	8.1%
o	9082	5.8%
t	8224	5.2%
i	8111	5.2%
n	7890	5.0%
C	5519	3.5%
l	5480	3.5%
S	5115	3.3%
Other values (50)	67291	42.8%

Engine
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

DoubleÃ‚Â Overhead Camshaft	12571
Overhead Camshaft	11335

Length

Max length	27
Median length	27
Mean length	22.258513
Min length	17

Characters and Unicode

Total characters	532112
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DoubleÃ‚Â Overhead Camshaft
2nd row	DoubleÃ‚Â Overhead Camshaft
3rd row	Overhead Camshaft
4th row	Overhead Camshaft
5th row	DoubleÃ‚Â Overhead Camshaft

Common Values

Value	Count	Frequency (%)
DoubleÃ‚Â Overhead Camshaft	12571	52.6%
Overhead Camshaft	11335	47.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
overhead	23906	39.6%
camshaft	23906	39.6%
doubleã‚â	12571	20.8%

Most occurring characters

Value	Count	Frequency (%)
a	71718	13.5%
e	60383	11.3%
h	47812	9.0%
v	23906	4.5%
r	23906	4.5%
f	23906	4.5%
s	23906	4.5%
m	23906	4.5%
C	23906	4.5%
	23906	4.5%
Other values (12)	184857	34.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	532112	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	71718	13.5%
e	60383	11.3%
h	47812	9.0%
v	23906	4.5%
r	23906	4.5%
f	23906	4.5%
s	23906	4.5%
m	23906	4.5%
C	23906	4.5%
	23906	4.5%
Other values (12)	184857	34.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	532112	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	71718	13.5%
e	60383	11.3%
h	47812	9.0%
v	23906	4.5%
r	23906	4.5%
f	23906	4.5%
s	23906	4.5%
m	23906	4.5%
C	23906	4.5%
	23906	4.5%
Other values (12)	184857	34.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	532112	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	71718	13.5%
e	60383	11.3%
h	47812	9.0%
v	23906	4.5%
r	23906	4.5%
f	23906	4.5%
s	23906	4.5%
m	23906	4.5%
C	23906	4.5%
	23906	4.5%
Other values (12)	184857	34.7%

Transmission
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Auto	12571
Manual	11335

Length

Max length	6
Median length	4
Mean length	4.9482975
Min length	4

Characters and Unicode

Total characters	118294
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Auto
2nd row	Auto
3rd row	Manual
4th row	Manual
5th row	Auto

Common Values

Value	Count	Frequency (%)
Auto	12571	52.6%
Manual	11335	47.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
auto	12571	52.6%
manual	11335	47.4%

Most occurring characters

Value	Count	Frequency (%)
u	23906	20.2%
a	22670	19.2%
A	12571	10.6%
t	12571	10.6%
o	12571	10.6%
M	11335	9.6%
n	11335	9.6%
l	11335	9.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	118294	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
u	23906	20.2%
a	22670	19.2%
A	12571	10.6%
t	12571	10.6%
o	12571	10.6%
M	11335	9.6%
n	11335	9.6%
l	11335	9.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	118294	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
u	23906	20.2%
a	22670	19.2%
A	12571	10.6%
t	12571	10.6%
o	12571	10.6%
M	11335	9.6%
n	11335	9.6%
l	11335	9.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	118294	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
u	23906	20.2%
a	22670	19.2%
A	12571	10.6%
t	12571	10.6%
o	12571	10.6%
M	11335	9.6%
n	11335	9.6%
l	11335	9.6%

Color
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Pale White	11256
Black	7857
Red	4793

Length

Max length	10
Median length	5
Mean length	6.9532335
Min length	3

Characters and Unicode

Total characters	166224
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Black
2nd row	Black
3rd row	Red
4th row	Pale White
5th row	Red

Common Values

Value	Count	Frequency (%)
Pale White	11256	47.1%
Black	7857	32.9%
Red	4793	20.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pale	11256	32.0%
white	11256	32.0%
black	7857	22.3%
red	4793	13.6%

Most occurring characters

Value	Count	Frequency (%)
e	27305	16.4%
a	19113	11.5%
l	19113	11.5%
P	11256	6.8%
	11256	6.8%
W	11256	6.8%
h	11256	6.8%
i	11256	6.8%
t	11256	6.8%
B	7857	4.7%
Other values (4)	25300	15.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	166224	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	27305	16.4%
a	19113	11.5%
l	19113	11.5%
P	11256	6.8%
	11256	6.8%
W	11256	6.8%
h	11256	6.8%
i	11256	6.8%
t	11256	6.8%
B	7857	4.7%
Other values (4)	25300	15.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	166224	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	27305	16.4%
a	19113	11.5%
l	19113	11.5%
P	11256	6.8%
	11256	6.8%
W	11256	6.8%
h	11256	6.8%
i	11256	6.8%
t	11256	6.8%
B	7857	4.7%
Other values (4)	25300	15.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	166224	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	27305	16.4%
a	19113	11.5%
l	19113	11.5%
P	11256	6.8%
	11256	6.8%
W	11256	6.8%
h	11256	6.8%
i	11256	6.8%
t	11256	6.8%
B	7857	4.7%
Other values (4)	25300	15.2%

Price_($)
Real number (ℝ)

HIGH CORRELATION

Distinct	870
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28090.248

Minimum	1200
Maximum	85800
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	186.9 KiB

Quantile statistics

Minimum	1200
5-th percentile	12000
Q1	18001
median	23000
Q3	34000
95-th percentile	61000
Maximum	85800
Range	84600
Interquartile range (IQR)	15999

Descriptive statistics

Standard deviation	14788.688
Coefficient of variation (CV)	0.52647053
Kurtosis	2.0083154
Mean	28090.248
Median Absolute Deviation (MAD)	6300
Skewness	1.4663159
Sum	6.7152546 × 10⁸
Variance	2.1870528 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22000	1191	5.0%
19000	974	4.1%
21000	873	3.7%
26000	689	2.9%
18000	627	2.6%
17000	621	2.6%
16000	620	2.6%
12000	619	2.6%
31000	604	2.5%
20000	533	2.2%
Other values (860)	16555	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1200	1	< 0.1%
1450	1	< 0.1%
1700	1	< 0.1%
2200	1	< 0.1%
4200	1	< 0.1%
4300	1	< 0.1%
9000	169	0.7%
9001	59	0.2%
9100	3	< 0.1%
9200	3	< 0.1%

Value	Count	Frequency (%)
85800	1	< 0.1%
85601	1	< 0.1%
85600	2	< 0.1%
85500	2	< 0.1%
85400	1	< 0.1%
85301	1	< 0.1%
85300	1	< 0.1%
85250	1	< 0.1%
85200	1	< 0.1%
85001	22	0.1%

Dealer_No
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

85257-3102	3814
53546-9427	3813
78758-7841	3753
06457-3834	3132
38701-8047	3132
Other values (2)	6262

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	239060
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	06457-3834
2nd row	60504-7114
3rd row	38701-8047
4th row	99301-3882
5th row	53546-9427

Common Values

Value	Count	Frequency (%)
85257-3102	3814	16.0%
53546-9427	3813	15.9%
78758-7841	3753	15.7%
06457-3834	3132	13.1%
38701-8047	3132	13.1%
99301-3882	3132	13.1%
60504-7114	3130	13.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
85257-3102	3814	16.0%
53546-9427	3813	15.9%
78758-7841	3753	15.7%
06457-3834	3132	13.1%
38701-8047	3132	13.1%
99301-3882	3132	13.1%
60504-7114	3130	13.1%

Most occurring characters

Value	Count	Frequency (%)
7	31412	13.1%
8	30733	12.9%
4	27035	11.3%
5	25269	10.6%
-	23906	10.0%
3	23287	9.7%
0	22602	9.5%
1	20091	8.4%
2	14573	6.1%
9	10077	4.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	239060	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
7	31412	13.1%
8	30733	12.9%
4	27035	11.3%
5	25269	10.6%
-	23906	10.0%
3	23287	9.7%
0	22602	9.5%
1	20091	8.4%
2	14573	6.1%
9	10077	4.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	239060	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
7	31412	13.1%
8	30733	12.9%
4	27035	11.3%
5	25269	10.6%
-	23906	10.0%
3	23287	9.7%
0	22602	9.5%
1	20091	8.4%
2	14573	6.1%
9	10077	4.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	239060	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
7	31412	13.1%
8	30733	12.9%
4	27035	11.3%
5	25269	10.6%
-	23906	10.0%
3	23287	9.7%
0	22602	9.5%
1	20091	8.4%
2	14573	6.1%
9	10077	4.2%

Body_Style
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

SUV	6374
Hatchback	6128
Sedan	4488
Passenger	3945
Hardtop	2971

Length

Max length	9
Median length	7
Mean length	6.4007362
Min length	3

Characters and Unicode

Total characters	153016
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SUV
2nd row	SUV
3rd row	Passenger
4th row	SUV
5th row	Hatchback

Common Values

Value	Count	Frequency (%)
SUV	6374	26.7%
Hatchback	6128	25.6%
Sedan	4488	18.8%
Passenger	3945	16.5%
Hardtop	2971	12.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
suv	6374	26.7%
hatchback	6128	25.6%
sedan	4488	18.8%
passenger	3945	16.5%
hardtop	2971	12.4%

Most occurring characters

Value	Count	Frequency (%)
a	23660	15.5%
e	12378	8.1%
c	12256	8.0%
S	10862	7.1%
H	9099	5.9%
t	9099	5.9%
n	8433	5.5%
s	7890	5.2%
d	7459	4.9%
r	6916	4.5%
Other values (9)	44964	29.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	153016	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	23660	15.5%
e	12378	8.1%
c	12256	8.0%
S	10862	7.1%
H	9099	5.9%
t	9099	5.9%
n	8433	5.5%
s	7890	5.2%
d	7459	4.9%
r	6916	4.5%
Other values (9)	44964	29.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	153016	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	23660	15.5%
e	12378	8.1%
c	12256	8.0%
S	10862	7.1%
H	9099	5.9%
t	9099	5.9%
n	8433	5.5%
s	7890	5.2%
d	7459	4.9%
r	6916	4.5%
Other values (9)	44964	29.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	153016	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	23660	15.5%
e	12378	8.1%
c	12256	8.0%
S	10862	7.1%
H	9099	5.9%
t	9099	5.9%
n	8433	5.5%
s	7890	5.2%
d	7459	4.9%
r	6916	4.5%
Other values (9)	44964	29.4%

Phone
Real number (ℝ)

Distinct	23804
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7497740.6

Minimum	6000101
Maximum	8999579
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	186.9 KiB

Quantile statistics

Minimum	6000101
5-th percentile	6146284
Q1	6746495
median	7496197.5
Q3	8248146.2
95-th percentile	8849134.5
Maximum	8999579
Range	2999478
Interquartile range (IQR)	1501651.2

Descriptive statistics

Standard deviation	867492
Coefficient of variation (CV)	0.11570045
Kurtosis	-1.1979186
Mean	7497740.6
Median Absolute Deviation (MAD)	750964
Skewness	0.00086348034
Sum	1.7924099 × 10¹¹
Variance	7.5254236 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6005535	2	< 0.1%
7298842	2	< 0.1%
6955907	2	< 0.1%
6854031	2	< 0.1%
8895808	2	< 0.1%
8389695	2	< 0.1%
7390875	2	< 0.1%
8168355	2	< 0.1%
8602618	2	< 0.1%
6257129	2	< 0.1%
Other values (23794)	23886	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6000101	1	< 0.1%
6000191	1	< 0.1%
6000247	1	< 0.1%
6000326	1	< 0.1%
6000356	1	< 0.1%
6000458	1	< 0.1%
6000493	1	< 0.1%
6000559	1	< 0.1%
6000740	1	< 0.1%
6000749	1	< 0.1%

Value	Count	Frequency (%)
8999579	1	< 0.1%
8999305	1	< 0.1%
8998913	1	< 0.1%
8998867	1	< 0.1%
8998864	1	< 0.1%
8998836	1	< 0.1%
8998761	1	< 0.1%
8998696	1	< 0.1%
8998568	1	< 0.1%
8998480	1	< 0.1%

Amount_paid_for_insurance
Real number (ℝ)

HIGH CORRELATION

Distinct	3421
Distinct (%)	14.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1654.5178

Minimum	103
Maximum	4762
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	186.9 KiB

Quantile statistics

Minimum	103
5-th percentile	808
Q1	1138
median	1432
Q3	1990
95-th percentile	3291
Maximum	4762
Range	4659
Interquartile range (IQR)	852

Descriptive statistics

Standard deviation	753.48166
Coefficient of variation (CV)	0.45540862
Kurtosis	1.8423571
Mean	1654.5178
Median Absolute Deviation (MAD)	357
Skewness	1.3806533
Sum	39552902
Variance	567734.62
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1369	32	0.1%
1163	32	0.1%
1307	31	0.1%
1311	31	0.1%
1275	30	0.1%
1325	30	0.1%
1408	30	0.1%
1305	30	0.1%
1069	29	0.1%
1321	29	0.1%
Other values (3411)	23602	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
103	1	< 0.1%
187	1	< 0.1%
450	1	< 0.1%
453	1	< 0.1%
460	1	< 0.1%
463	1	< 0.1%
464	2	< 0.1%
465	1	< 0.1%
470	1	< 0.1%
471	2	< 0.1%

Value	Count	Frequency (%)
4762	1	< 0.1%
4753	1	< 0.1%
4749	1	< 0.1%
4748	1	< 0.1%
4738	1	< 0.1%
4737	1	< 0.1%
4733	1	< 0.1%
4726	1	< 0.1%
4724	1	< 0.1%
4698	1	< 0.1%

Claim_amount
Real number (ℝ)

ZEROS

Distinct	230
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	282.46327

Minimum	0
Maximum	8560
Zeros	21516
Zeros (%)	90.0%
Negative	0
Negative (%)	0.0%
Memory size	186.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2200
Maximum	8560
Range	8560
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	977.50653
Coefficient of variation (CV)	3.46065
Kurtosis	20.505985
Mean	282.46327
Median Absolute Deviation (MAD)	0
Skewness	4.2414879
Sum	6752567
Variance	955519.01
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21516	90.0%
2200	150	0.6%
1900	138	0.6%
2100	112	0.5%
1600	95	0.4%
1700	94	0.4%
1200	92	0.4%
2600	80	0.3%
3100	77	0.3%
1800	77	0.3%
Other values (220)	1475	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21516	90.0%
145	1	< 0.1%
900	19	0.1%
925	1	< 0.1%
950	3	< 0.1%
960	1	< 0.1%
980	1	< 0.1%
1000	17	0.1%
1040	1	< 0.1%
1050	1	< 0.1%

Value	Count	Frequency (%)
8560	3	< 0.1%
8540	1	< 0.1%
8530	1	< 0.1%
8500	6	< 0.1%
8250	1	< 0.1%
8200	11	< 0.1%
7560	1	< 0.1%
7550	1	< 0.1%
7510	1	< 0.1%
7500	15	0.1%

City
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

Liepaja	4057
Tukums	4008
Riga	3987
Daugavpils	3976
Jelgava	3960

Length

Max length	10
Median length	9
Mean length	7.1587468
Min length	4

Characters and Unicode

Total characters	171137
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Riga
2nd row	Liepaja
3rd row	Riga
4th row	Jelgava
5th row	Liepaja

Common Values

Value	Count	Frequency (%)
Liepaja	4057	17.0%
Tukums	4008	16.8%
Riga	3987	16.7%
Daugavpils	3976	16.6%
Jelgava	3960	16.6%
Ventspils	3918	16.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
liepaja	4057	17.0%
tukums	4008	16.8%
riga	3987	16.7%
daugavpils	3976	16.6%
jelgava	3960	16.6%
ventspils	3918	16.4%

Most occurring characters

Value	Count	Frequency (%)
a	27973	16.3%
i	15938	9.3%
s	15820	9.2%
u	11992	7.0%
p	11951	7.0%
e	11935	7.0%
g	11923	7.0%
l	11854	6.9%
v	7936	4.6%
L	4057	2.4%
Other values (10)	39758	23.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	171137	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	27973	16.3%
i	15938	9.3%
s	15820	9.2%
u	11992	7.0%
p	11951	7.0%
e	11935	7.0%
g	11923	7.0%
l	11854	6.9%
v	7936	4.6%
L	4057	2.4%
Other values (10)	39758	23.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	171137	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	27973	16.3%
i	15938	9.3%
s	15820	9.2%
u	11992	7.0%
p	11951	7.0%
e	11935	7.0%
g	11923	7.0%
l	11854	6.9%
v	7936	4.6%
L	4057	2.4%
Other values (10)	39758	23.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	171137	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	27973	16.3%
i	15938	9.3%
s	15820	9.2%
u	11992	7.0%
p	11951	7.0%
e	11935	7.0%
g	11923	7.0%
l	11854	6.9%
v	7936	4.6%
L	4057	2.4%
Other values (10)	39758	23.2%

Year
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	186.9 KiB

2023	13261
2022	10645

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	95624
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2022
2nd row	2022
3rd row	2022
4th row	2022
5th row	2022

Common Values

Value	Count	Frequency (%)
2023	13261	55.5%
2022	10645	44.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023	13261	55.5%
2022	10645	44.5%

Most occurring characters

Value	Count	Frequency (%)
2	58457	61.1%
0	23906	25.0%
3	13261	13.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	95624	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	58457	61.1%
0	23906	25.0%
3	13261	13.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	95624	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	58457	61.1%
0	23906	25.0%
3	13261	13.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	95624	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	58457	61.1%
0	23906	25.0%
3	13261	13.9%

Month
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.852924

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.5 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	9
Q3	11
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.2579854
Coefficient of variation (CV)	0.41487546
Kurtosis	-0.99435964
Mean	7.852924
Median Absolute Deviation (MAD)	2
Skewness	-0.41558155
Sum	187732
Variance	10.614469
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	3546	14.8%
11	3470	14.5%
9	3305	13.8%
5	1895	7.9%
10	1830	7.7%
7	1725	7.2%
6	1715	7.2%
8	1705	7.1%
4	1655	6.9%
3	1535	6.4%
Other values (2)	1525	6.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	790	3.3%
2	735	3.1%
3	1535	6.4%
4	1655	6.9%
5	1895	7.9%
6	1715	7.2%
7	1725	7.2%
8	1705	7.1%
9	3305	13.8%
10	1830	7.7%

Value	Count	Frequency (%)
12	3546	14.8%
11	3470	14.5%
10	1830	7.7%
9	3305	13.8%
8	1705	7.1%
7	1725	7.2%
6	1715	7.2%
5	1895	7.9%
4	1655	6.9%
3	1535	6.4%

Day
Real number (ℝ)

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.473061

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.5 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7341721
Coefficient of variation (CV)	0.56447603
Kurtosis	-1.1906513
Mean	15.473061
Median Absolute Deviation (MAD)	7
Skewness	0.036949301
Sum	369899
Variance	76.285762
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
5	1005	4.2%
8	975	4.1%
12	940	3.9%
26	930	3.9%
21	905	3.8%
25	880	3.7%
13	880	3.7%
17	840	3.5%
3	835	3.5%
10	805	3.4%
Other values (21)	14911	62.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	795	3.3%
2	755	3.2%
3	835	3.5%
4	765	3.2%
5	1005	4.2%
6	705	2.9%
7	675	2.8%
8	975	4.1%
9	725	3.0%
10	805	3.4%

Value	Count	Frequency (%)
31	495	2.1%
30	615	2.6%
29	551	2.3%
28	705	2.9%
27	670	2.8%
26	930	3.9%
25	880	3.7%
24	760	3.2%
23	800	3.3%
22	725	3.0%

Auto

Heatmap
Table

	Amount_paid_for_insurance	Annual_Income	Body_Style	City	Claim_amount	Color	Company	Day	Dealer_Name	Dealer_No	Engine	Gender	Month	Phone	Price_($)	Transmission	Year
Amount_paid_for_insurance	1.000	0.012	0.084	0.000	0.014	0.093	0.158	-0.002	0.000	0.000	0.135	0.000	0.005	0.000	0.952	0.135	0.000
Annual_Income	0.012	1.000	0.006	0.011	-0.001	0.000	0.011	0.008	0.000	0.000	0.000	0.063	-0.008	-0.002	0.017	0.000	0.041
Body_Style	0.084	0.006	1.000	0.000	-0.001	0.036	0.316	0.002	0.000	0.000	0.083	0.000	-0.016	-0.010	0.014	0.083	0.065
City	0.000	0.011	0.000	1.000	0.003	0.000	0.000	-0.000	0.011	0.009	0.000	0.000	0.021	-0.010	0.004	0.000	0.018
Claim_amount	0.014	-0.001	-0.001	0.003	1.000	0.028	0.068	0.004	0.004	0.000	0.070	0.000	0.001	-0.004	0.014	0.070	0.000
Color	0.093	0.000	0.036	0.000	0.028	1.000	0.183	0.007	0.000	0.000	0.000	0.000	-0.030	0.002	-0.006	0.000	0.030
Company	0.158	0.011	0.316	0.000	0.068	0.183	1.000	0.010	0.000	0.000	0.250	0.018	-0.002	0.002	0.024	0.250	0.000
Day	-0.002	0.008	0.002	-0.000	0.004	0.007	0.010	1.000	0.000	0.000	0.014	0.000	-0.015	-0.005	-0.002	0.014	0.043
Dealer_Name	0.000	0.000	0.000	0.011	0.004	0.000	0.000	0.000	1.000	1.000	0.000	0.010	-0.000	-0.004	0.007	0.000	0.000
Dealer_No	0.000	0.000	0.000	0.009	0.000	0.000	0.000	0.000	1.000	1.000	0.000	0.000	0.001	-0.011	0.004	0.000	0.000
Engine	0.135	0.000	0.083	0.000	0.070	0.000	0.250	0.014	0.000	0.000	1.000	0.000	-0.008	-0.005	-0.058	1.000	0.007
Gender	0.000	0.063	0.000	0.000	0.000	0.000	0.018	0.000	0.010	0.000	0.000	1.000	0.035	-0.002	-0.003	0.000	0.028
Month	0.005	-0.008	-0.016	0.021	0.001	-0.030	-0.002	-0.015	-0.000	0.001	-0.008	0.035	1.000	0.005	0.006	0.006	0.052
Phone	0.000	-0.002	-0.010	-0.010	-0.004	0.002	0.002	-0.005	-0.004	-0.011	-0.005	-0.002	0.005	1.000	-0.000	0.000	0.000
Price_($)	0.952	0.017	0.014	0.004	0.014	-0.006	0.024	-0.002	0.007	0.004	-0.058	-0.003	0.006	-0.000	1.000	0.209	0.000
Transmission	0.135	0.000	0.083	0.000	0.070	0.000	0.250	0.014	0.000	0.000	1.000	0.000	0.006	0.000	0.209	1.000	0.007
Year	0.000	0.041	0.065	0.018	0.000	0.030	0.000	0.043	0.000	0.000	0.007	0.028	0.052	0.000	0.000	0.007	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Car_id	Date	Customer_Name	Gender	Annual_Income	Dealer_Name	Company	Model	Engine	Transmission	Color	Price_($)	Dealer_No	Body_Style	Phone	Amount_paid_for_insurance	Claim_amount	City	Year	Month	Day
0	C_CND_000001	2022-01-02	Geraldine	Male	13500	Buddy Storbeck's Diesel Service Inc	Ford	Expedition	DoubleÃ‚Â Overhead Camshaft	Auto	Black	26000	06457-3834	SUV	8264678	1665	0.00	Riga	2022	1	2
1	C_CND_000002	2022-01-02	Gia	Male	1480000	C & M Motors Inc	Dodge	Durango	DoubleÃ‚Â Overhead Camshaft	Auto	Black	19000	60504-7114	SUV	6848189	1332	1900.00	Liepaja	2022	1	2
2	C_CND_000003	2022-01-02	Gianna	Male	1035000	Capitol KIA	Cadillac	Eldorado	Overhead Camshaft	Manual	Red	31500	38701-8047	Passenger	7298798	1897	0.00	Riga	2022	1	2
3	C_CND_000004	2022-01-02	Giselle	Male	13500	Chrysler of Tri-Cities	Toyota	Celica	Overhead Camshaft	Manual	Pale White	14000	99301-3882	SUV	6257557	1176	0.00	Jelgava	2022	1	2
4	C_CND_000005	2022-01-02	Grace	Male	1465000	Chrysler Plymouth	Acura	TL	DoubleÃ‚Â Overhead Camshaft	Auto	Red	24500	53546-9427	Hatchback	7081483	1323	2450.00	Liepaja	2022	1	2
5	C_CND_000006	2022-01-02	Guadalupe	Male	850000	Classic Chevy	Mitsubishi	Diamante	Overhead Camshaft	Manual	Pale White	12000	85257-3102	Hatchback	7315216	830	0.00	Riga	2022	1	2
6	C_CND_000007	2022-01-02	Hailey	Male	1600000	Clay Johnson Auto Sales	Toyota	Corolla	Overhead Camshaft	Manual	Pale White	14000	78758-7841	Passenger	7727879	717	0.00	Riga	2022	1	2
7	C_CND_000008	2022-01-02	Graham	Male	13500	U-Haul CO	Mitsubishi	Galant	DoubleÃ‚Â Overhead Camshaft	Auto	Pale White	42000	78758-7841	Passenger	6206512	2183	0.00	Jelgava	2022	1	2
8	C_CND_000009	2022-01-02	Naomi	Male	815000	Rabun Used Car Sales	Chevrolet	Malibu	Overhead Camshaft	Manual	Pale White	82000	85257-3102	Hardtop	7194857	4206	0.00	Ventspils	2022	1	2
9	C_CND_000010	2022-01-02	Grayson	Female	13500	Rabun Used Car Sales	Ford	Escort	DoubleÃ‚Â Overhead Camshaft	Auto	Pale White	15000	85257-3102	Passenger	7836892	873	0.00	Ventspils	2022	1	2

	Car_id	Date	Customer_Name	Gender	Annual_Income	Dealer_Name	Company	Model	Engine	Transmission	Color	Price_($)	Dealer_No	Body_Style	Phone	Amount_paid_for_insurance	Claim_amount	City	Year	Month	Day
23896	C_CND_023897	2023-12-31	Simi	Male	761000	Rabun Used Car Sales	Dodge	Viper	DoubleÃ‚Â Overhead Camshaft	Auto	Red	41000	85257-3102	SUV	8744249	2214	0.00	Daugavpils	2023	12	31
23897	C_CND_023898	2023-12-31	Simone	Male	520000	Progressive Shippers Cooperative Association No	Mercedes-B	E-Class	DoubleÃ‚Â Overhead Camshaft	Auto	Red	15000	53546-9427	Sedan	6819422	1178	0.00	Ventspils	2023	12	31
23898	C_CND_023899	2023-12-31	Skylar	Male	530000	Rabun Used Car Sales	Volvo	C70	Overhead Camshaft	Manual	Pale White	24000	85257-3102	Hatchback	6225183	1649	2400.00	Liepaja	2023	12	31
23899	C_CND_023900	2023-12-31	Yuna	Male	13500	U-Haul CO	Buick	Park Avenue	DoubleÃ‚Â Overhead Camshaft	Auto	Pale White	62000	78758-7841	Hatchback	8384785	3309	0.00	Ventspils	2023	12	31
23900	C_CND_023901	2023-12-31	Nathan	Female	771000	Buddy Storbeck's Diesel Service Inc	Ford	Contour	DoubleÃ‚Â Overhead Camshaft	Auto	Red	19000	06457-3834	Sedan	8170003	1036	0.00	Jelgava	2023	12	31
23901	C_CND_023902	2023-12-31	Martin	Male	13500	C & M Motors Inc	Plymouth	Voyager	Overhead Camshaft	Manual	Red	12000	60504-7114	Passenger	8583598	692	1200.00	Tukums	2023	12	31
23902	C_CND_023903	2023-12-31	Jimmy	Female	900000	Ryder Truck Rental and Leasing	Chevrolet	Prizm	DoubleÃ‚Â Overhead Camshaft	Auto	Black	16000	06457-3834	Hardtop	7914229	1072	0.00	Liepaja	2023	12	31
23903	C_CND_023904	2023-12-31	Emma	Male	705000	Chrysler of Tri-Cities	BMW	328i	Overhead Camshaft	Manual	Red	21000	99301-3882	Sedan	7659127	1061	0.00	Liepaja	2023	12	31
23904	C_CND_023905	2023-12-31	Victoire	Male	13500	Chrysler Plymouth	Chevrolet	Metro	DoubleÃ‚Â Overhead Camshaft	Auto	Black	31000	53546-9427	Passenger	6030764	1922	3100.00	Tukums	2023	12	31
23905	C_CND_023906	2023-12-31	Donovan	Male	1225000	Pars Auto Sales	Lexus	ES300	DoubleÃ‚Â Overhead Camshaft	Auto	Pale White	27500	38701-8047	Hardtop	7020564	1492	0.00	Tukums	2023	12	31

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks